// jdbcsh - An interactive shell for JDBC databases
// Copyright (C) 2007 Dan Boitnott
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

package jdbcsh;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;

/**
 *
 * @author Dan Boitnott
 */
public class FilteredResultSetTable implements Table {
    private class Pair {
        public String k;
        public String v;
        
        public Pair() {}
        public Pair(String kk, String vv) {
            k = kk;
            v = vv;
        }
    }
    
    private ResultSet res;
    private ResultSetMetaData meta;    
    private final ArrayList<Pair> cols = new ArrayList<Pair>();
    
    public FilteredResultSetTable(ResultSet r) {
        try {
            res = r;
            meta = r.getMetaData();
        } catch (SQLException ex) {
            throw new RuntimeException(ex);
        }
    }
    
    public void addColumn(String key, String label) {
        cols.add(new Pair(key, label));
    }

    public int getColumnCount() {
        return cols.size();
    }

    public int getColumnDisplaySize(int column) {
        try {
            return meta.getColumnDisplaySize(res.findColumn(cols.get(column).k));
        } catch (SQLException ex) {
            throw new RuntimeException(ex);
        }
    }

    public String getColumnLabel(int column) {
        return cols.get(column).v;
    }

    public String getString(int column) {
        try {
            return res.getString(cols.get(column).k);
        } catch (SQLException ex) {
            throw new RuntimeException(ex);
        }
    }

    public boolean next() {
        try {
            return res.next();
        } catch (SQLException ex) {
            throw new RuntimeException(ex);
        }
    }
}
